package com.wu.utils;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;

import java.io.InputStream;
import java.sql.Connection;
import java.util.Properties;

public class JdbcUtils {

    private static DruidDataSource dataSource;
    static {
      try{
          Properties properties=new Properties();
          //读取jdbc.properties文件
          InputStream inputStream=JdbcUtils.class.getClassLoader().getResourceAsStream("jdbc.properties");
          //从流中加载数据
          properties.load(inputStream);
          //创建数据库链接池
          dataSource= (DruidDataSource) DruidDataSourceFactory.createDataSource(properties);
      }catch (Exception e){
          e.printStackTrace();
      }
    }

    /**
     * 获取连接池中的连接
     * @return 返回null说明获取失败
     */
    public static Connection getConnection()
    {
        Connection conn=null;
        try{
            conn=dataSource.getConnection();
        }catch (Exception e)
        {
            e.printStackTrace();
        }
        return conn;
    }

    /**
     * 关闭连接池
     * @param conn
     */
    public static void close(Connection conn)
    {

            if(conn!=null)
            {
                try {
                    conn.close();
                }catch (Exception e)
                {
                    e.printStackTrace();
                }

            }

    }
}
